class CreateConversations < ActiveRecord::Migration
  def self.up
    create_table :conversations do |t|
      t.column  :customer_id,       :integer
      t.column  :contact_id,        :integer
      t.column  :user_id,           :integer
      t.column  :contacted_on,      :date
      t.column  :conversation_type, :string
      t.column  :content,           :text
      t.column  :created_on,        :timestamp
      t.column  :updated_on,        :timestamp
      t.column  :lock_version,      :integer, :default => 0
    end
  end
  
  def self.down
    drop_table :conversations
  end
end
